You are here: Main Menu > I. Interface Menu > 7. External System > 5. ESI Purchases

ESI Purchases

The ESI Purchases function is used to export the completed purchase order details for a specific period and year

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. At the Period field, enter the accounting period for ESI purchases file.

3. At the Year field, enter the year for the ESI purchases file.

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

Select no to return to the Period field.
Select yes to create a new file with the same name that already exists.

4. The following message will display: "Print report? No/Yes."

Select no to generate the export file without a printed detail report. You will return to the Period field.
Select yes to create the file with a printed detail report.

5. The following message will appear: "Create a delimited ASC file? No/Yes."

Select no to create a DBF file only.
Select yes to create a DBF file and an ASC file.

Select the appropriate option.

5. If you selected yes in Step #4 to print an ESI purchases report, command options will appear allowing you to print or choose from a set of other print options.

Two DBF files will be created, TBPPYYYY.dbf and TB_Last.dbf, in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The TBPPYYYY.dbf file is the ESI trial balance file for the selected period and year with PPYYYY equal to the period and year selected. The TB_Last.dbf is a copy of the current file. If an ASC file is created the name will be TBPPYYYY.asc and will be in the Shared \NetYield\Data\Company Name\ESI Outbox folder.

The following information will print:

Ty – The purchase order type.
- PO – Purchase order
Voucher – The purchase order number
Vendor – The vendor ID
Invoice – The vendor invoice number
Date – The purchase order date
Cat – The sales category
Group – The item class and item subclass
Item – The item name
Qty to Inv – The quantity added to inventory when the purchase order was received.
Qty to AP – The quantity which has been invoiced and posted to accounts payable, in the invoicing unit of measure
Cost – The cost of the item
Un – The item unit – LB or EA
Amount – The total amount of the purchase order.

The following information will be exported from the system:

Field Name	Description	Type
LICNUMBER	The Net•Yield license number	C 4
PERIOD	The accounting period for the transaction	C 2
YEAR	The accounting year for the transaction	C 4
TYPE	The type of transaction: PO – Purchase order	C 2
VOUCHER	The purchase order number	C 5
ORIG_VOUCHER	Not applicable	C 5
VENDOR	The vendor ID	C 6
VENDORNAME	The vendor name	C 40
BUYER	The buyer ID	C 10
FOB	The freight on board description from the purchase order header	C 8
INVOICE	The vendor invoice number	C 10
DESC	The purchase order header description	C 30
RECEIVED	The purchase order received date	D 8
ITEM	The item code	C 8
ITEMNAME	The item name	C 30
MGMT_GROUP	The item class	C 2
GROUP	The item subclass	C 3
LOCATION	The received location, if the item is lotted	C 2
SALES_CAT	The sales category	C 2
QTYTOINV	The received quantity on the purchase order	N 11, 4
QTYTOAP	The paid quantity on the purchase order	N 9, 2
COSTTOAP	The total cost of the item	N 11, 4
UNIT	The received unit of measures	C 2
OLD_VENDOR	The old vendor ID, if applicable	C 6
ITEMCORPID	The corporate ID for the item	C 8
VENDCORPID	The vendor corporate ID	C 8

Security Required : Payables - Payable Reports